BEGIN TRANSACTION AddMember1
	BEGIN TRY
		INSERT INTO [Member] (MemberNo, FirstName, Surname, DOB, AddressRegionCode,  PhoneNo, EmailAddress, CardNo, CardCVV, CardExpiryDate)
		VALUES (1, 'Joana', 'Markez', '27-11-1983', '01', 07965842658, 'joanamarkez@gmail.com', '4933 1234 4321 2222', '123', '07-21')
		
		COMMIT TRANSACTION AddMember1
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddMember1
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddMember2
	BEGIN TRY
		INSERT INTO [Member] (MemberNo, FirstName, Surname, DOB, AddressRegionCode,  PhoneNo, EmailAddress, CardNo, CardCVV, CardExpiryDate)
		VALUES (2, 'Jenny', 'Numbry', '21-09-1979', '01', 07963342658, 'jnumbry@gmail.com', '4933 1234 4321 1111', '124', '06-20')
		
		COMMIT TRANSACTION AddMember2
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddMember2
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddMember3
	BEGIN TRY
		INSERT INTO [Member] (MemberNo, FirstName, Surname, DOB, AddressRegionCode,  PhoneNo, EmailAddress, CardNo, CardCVV, CardExpiryDate)
		VALUES (3, 'Adam', 'Stefz', '7-11-1992', '02', 07965992658, 'adamstefz@gmail.com', '4933 1234 4321 331', '223', '09-21')
		
		COMMIT TRANSACTION AddMember3
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddMember3
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddMember4
	BEGIN TRY
		INSERT INTO [Member] (MemberNo, FirstName, Surname, DOB, AddressRegionCode,  PhoneNo, EmailAddress, CardNo, CardCVV, CardExpiryDate)
		VALUES (4, 'Leanne', 'Jordan', '2-1-1993', '02', 07965112658, 'leannejordan@gmail.com', '4933 1234 4321 2211', '122', '05-23')
		
		COMMIT TRANSACTION AddMember4
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddMember4
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;